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