UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qnB2fj3GlLgWM15s/8ihg3bBWGxHXqYANcu2C7f0mCI='
WHERE
key_id = '1bef70fc81662e2175df1a48ba8c8382b85678dafb27ef4c6e099285741b841c'
AND (
token = 'qnB2fj3GlLgWM15s/8ihg3bBWGxHXqYANcu2C7f0mCI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)