UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XXyj9MOKDFMnW7PWHv5zHRzWaUDyzCnw1L7A7tiqO8c='
WHERE
key_id = 'b10a1091276143b274fe9d98e49e3bf7fdfd4ccc6daafc8e10e27f163e3534cd'
AND (
token = 'XXyj9MOKDFMnW7PWHv5zHRzWaUDyzCnw1L7A7tiqO8c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)