UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9/BWplhnTxK51ZqBlA7QcQwflKZhOaXR7lilni2Y5os='
WHERE
key_id = '8687a32458872693f16e5dcc240181b6ab438a1ba477436109e783043026839e'
AND (
token = '9/BWplhnTxK51ZqBlA7QcQwflKZhOaXR7lilni2Y5os='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)