UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bnQMAc/vsbXgSkapo8Wa2gbvKjU3DR0b+8seOrOf2Xk='
WHERE
key_id = '87162eef31e63eda0bb63f3ab5fc75fec8171a3aca1af482c6b564d093dca509'
AND (
token = 'bnQMAc/vsbXgSkapo8Wa2gbvKjU3DR0b+8seOrOf2Xk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)