UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '16E46zMnMT+fbrt3KC/YtzS1LEEPz9E0Bi5M9xb/IsY='
WHERE
key_id = 'd8648fd25ba0f0d6fa737077b629981afdbd06d7d5418ae6a79ebea251e30fa3'
AND (
token = '16E46zMnMT+fbrt3KC/YtzS1LEEPz9E0Bi5M9xb/IsY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)