UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'irG/sLHTYjydEDV1JmzNRCRcDBeIpwVl5hPjhMJV9fk='
WHERE
key_id = '48fc6c2a3f580c1e50b886a89fe7cd2a46dfe86d9f2317701673a94b35936eab'
AND (
token = 'irG/sLHTYjydEDV1JmzNRCRcDBeIpwVl5hPjhMJV9fk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)