UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hX0eL2U3Icf0qvRjmSCCpVrF+OBuej8w5sK85d8NFGU='
WHERE
key_id = 'f48859b80c382769e43632a1cdfc69971b1af94c73ac11f50d7752430bdf8cf7'
AND (
token = 'hX0eL2U3Icf0qvRjmSCCpVrF+OBuej8w5sK85d8NFGU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)