UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RRhs1VRBaAp0ji4cYpvERglWHB6ULU/9X/jIBjEcW3s='
WHERE
key_id = 'd6dc22291e19cd9f290dc59e7634ddf512c145a1a11be0e1a7f9c37cc67f0d82'
AND (
token = 'RRhs1VRBaAp0ji4cYpvERglWHB6ULU/9X/jIBjEcW3s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)