UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1gs6yqabbSmhrFGpPNXTWntVj9apZhE/4uagH4GzE9M='
WHERE
key_id = '1e53d2809e69c9df3c4485fbac337fa88907ba0dc067ddb879d5499ad77eeab5'
AND (
token = '1gs6yqabbSmhrFGpPNXTWntVj9apZhE/4uagH4GzE9M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)