UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3A79+exFe4n6DAaOpKGWNQQ9hgii0skS89maTi88ASc='
WHERE
key_id = '865db6c49efde6b8b7b51f77c752676abe86334823ceff4ceb0908fa51b3a987'
AND (
token = '3A79+exFe4n6DAaOpKGWNQQ9hgii0skS89maTi88ASc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)