UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7SUTWJE2ddG43gxF+HY/Urmdscu+UqFevinvZeo/xvU='
WHERE
key_id = '3f9518c8fa80468a5604291d4aa97b1372636cc7b3d0cece8eaf147e538f867e'
AND (
token = '7SUTWJE2ddG43gxF+HY/Urmdscu+UqFevinvZeo/xvU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)