UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1qUJj1ZGciS5pso65PibS0GPMy2cOcI3XcY2rVZNxpo='
WHERE
key_id = '69bf7ab8a681c2ea14cf84331919bac4c92576175ebf9e15de4d12f1cf265093'
AND (
token = '1qUJj1ZGciS5pso65PibS0GPMy2cOcI3XcY2rVZNxpo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)