UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dt+xAfAJzaWA4mE5oS8jLJyRf6nDjFpmgSDc0gIv/ig='
WHERE
key_id = 'c86e106a9ed8d577070da8190e6ec4d537a53050ebc816f134dc6d1a4d40278e'
AND (
token = 'dt+xAfAJzaWA4mE5oS8jLJyRf6nDjFpmgSDc0gIv/ig='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)