UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a41DCW1ysRgXw2NMAx9PAvM7t1iphjKr2SvyrLyNaqQ='
WHERE
key_id = '9f80797605fc55a269b2123e4d8d3aa4bbfde2f31ea15daa09e708e4d4c12cdc'
AND (
token = 'a41DCW1ysRgXw2NMAx9PAvM7t1iphjKr2SvyrLyNaqQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)