UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'x8ztsLKA8GQRrMvIvWroUsMuFuWZ/a7jjhFJvYBHNf0='
WHERE
key_id = 'f3c4cd7766e8c3a3c50b7e52c16243f6ca232a50091fed9bee33157beee61a45'
AND (
token = 'x8ztsLKA8GQRrMvIvWroUsMuFuWZ/a7jjhFJvYBHNf0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)