UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'd9nhsKbqZq6gf9MTQ2nHftHlW8Ypxt7VchDcb3Z+FNU='
WHERE
key_id = '9d2f19b5ad4a389003ea8a4011cd7b084b4ae4c524921a2ec7bb4a3919527f72'
AND (
token = 'd9nhsKbqZq6gf9MTQ2nHftHlW8Ypxt7VchDcb3Z+FNU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)