UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'h49QF+MtHvZZ5THJyYZJyiMSsNV9U9RM4KoInAckJek='
WHERE
key_id = '59b25b21cfa8ca334eead06c06f5982c5883423e411fa4208eb6a04d4e5be4ba'
AND (
token = 'h49QF+MtHvZZ5THJyYZJyiMSsNV9U9RM4KoInAckJek='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)