UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7+GuLivgbdqPIi/OJ3wzzcRwGE+lmnfTweASAPMnE3k='
WHERE
key_id = '4714266a094f45c2d2702e30a0155190abdccbc364839a76b0d0f6909e441a50'
AND (
token = '7+GuLivgbdqPIi/OJ3wzzcRwGE+lmnfTweASAPMnE3k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)