UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hgWaHrZOG2pN9U243Pa9lIut0QcJjXy4CbZXlCP+A9E='
WHERE
key_id = '830f090a4492ddf390b5e3d48d10df8ceed41d22c63291bc7d22099ee210691a'
AND (
token = 'hgWaHrZOG2pN9U243Pa9lIut0QcJjXy4CbZXlCP+A9E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)