UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ubyh0S2kcgAuFs5rOLPx9iiY9elqMwmcy4o6k/DQjHU='
WHERE
key_id = 'f0d13b66602a28fce49deefebcf7a7c75d26fb3e22626eaa59ea75ae2623bac6'
AND (
token = 'ubyh0S2kcgAuFs5rOLPx9iiY9elqMwmcy4o6k/DQjHU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)