UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pLBjaPjHrzITpfGub4k0aeoGXALw+Ol4b7zb9c1idNE='
WHERE
key_id = 'ce4c7af9c3fe0d3584a7a330d57e2fef424ca560378afa58619013412fcab008'
AND (
token = 'pLBjaPjHrzITpfGub4k0aeoGXALw+Ol4b7zb9c1idNE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)