UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XphvKBMMGoK/KhBj/ept1dKN/j4YBi31cKUcZ0oY2uo='
WHERE
key_id = '9ac978397145cc96a1d2b0cd002868aa0c769da6b9edee3f4a332946b90e7fad'
AND (
token = 'XphvKBMMGoK/KhBj/ept1dKN/j4YBi31cKUcZ0oY2uo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)