UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RvAm6GOFrRC3gXpjRyhHEPJHg33jkr82wFmq/fvHlz0='
WHERE
key_id = '389f0fca597f922203afe568cd8a40f7ffe45db61f18d2b20c552982881a4199'
AND (
token = 'RvAm6GOFrRC3gXpjRyhHEPJHg33jkr82wFmq/fvHlz0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)