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