UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0IOT8OzRF5PDRi4P1RFmdxKmQv3ws7P0zbM9RsNJvHM='
WHERE
key_id = 'a4f610d48789017562caca175f61ac548b457be1843c0cfc9e3ff44251a3831e'
AND (
token = '0IOT8OzRF5PDRi4P1RFmdxKmQv3ws7P0zbM9RsNJvHM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)