UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hoeO7TvZ231YTp0vOScEDtyiZZc7XLe3gift2NrgS+c='
WHERE
key_id = '3c8917793e926247ddf808fce686c24ea123b20a9d07a4e4206710d33e5bbbba'
AND (
token = 'hoeO7TvZ231YTp0vOScEDtyiZZc7XLe3gift2NrgS+c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)