UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BgeVyU5KTi0L8RElItGwaVUP/QD6cKAUTQjmkFV0lk8='
WHERE
key_id = '338332307288591e282c4ac44b98de907737cc47a0fd09df0683b761ea500517'
AND (
token = 'BgeVyU5KTi0L8RElItGwaVUP/QD6cKAUTQjmkFV0lk8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)