UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XzNkuZe7m+GscPJkbbRlxi1lqrc7cyP+23URWnFLua0='
WHERE
key_id = 'bcf34fe88ea58235a490806963aa4e53ea97b4b0584604acb9bd28bbfa6698cb'
AND (
token = 'XzNkuZe7m+GscPJkbbRlxi1lqrc7cyP+23URWnFLua0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)