UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2wGGdklVGzewABDM/Uuc//sX7F9Y6oU8mIDoXCcgGio='
WHERE
key_id = 'a6b584e2f8d13deaddf8fbe58a98ed2e623104c8cd7764ff1b52412e8778a6f1'
AND (
token = '2wGGdklVGzewABDM/Uuc//sX7F9Y6oU8mIDoXCcgGio='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)