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